package com.example.javaeefinal.Mapper;

import com.example.javaeefinal.pojo.Supplier;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Auther: Lai Wenhao
 * @Date: 2023/12/27 20:25
 **/
@Mapper
public interface SupplierMapper {
//    查找实体信息
    @Select("\n" +
            "SELECT f_id AS id,\n" +
            "       f_name AS supplierName\n" +
            "FROM t_supplier\n" +
            "WHERE f_id= #{id};")
    Supplier getSupplierById(int id);
}
